USE [aspnetdb]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- Description:	Get the share options
-- =============================================
create procedure sp_GetShareOptions(
	@par_userid int)
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
BEGIN
	SELECT [Document].doc_title as [Title], [Doc_Share].sh_check as [Check]
	FROM Doc_Share INNER JOIN [Document] ON Doc_Share.doc_id = [Document].doc_id INNER JOIN
                      [User1] ON Doc_Share.user_origin_id = [User1].user1_id and Doc_Share.sh_check = 'false' and Doc_Share.user_target_id = @par_userid
END